package com.school.mapper;

import com.school.model.OutPutScore;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.util.List;

@Mapper
@Repository
public interface StuInfoMapper {
    int addStuInfo(@Param("stuNo") String stuNo,@Param("stuName") String stuName);
    int addStuScore(@Param("stuNo") String stuNo,@Param("stuScore") BigDecimal stuScore
            ,@Param("scoreType") String scoreType);
    List<OutPutScore> getFinalExam();
    List<OutPutScore> getPerformance();
    List<OutPutScore> getHomeWork();
    List<OutPutScore> getTest();
    void truncateStuInfo();
    void truncateScoreInfo();

}
